﻿
CREATE PROCEDURE [dbo].[SYS_Provider_Update]
(
	@ProviderId  int,
	@ProviderTypeId  int,
	@Name  varchar(50),
	@Description  varchar(8000),
	@ConfigurationControlPath  varchar(200),
	@UpdateBy int
)

AS

UPDATE SYS_Provider

	SET 
		[ProviderTypeId] = @ProviderTypeId,
		[Name] = @Name,
		[Description] = @Description,
		[ConfigurationControlPath] = @ConfigurationControlPath,
		[UpdateDate] = getdate()
	WHERE [ProviderId] = @ProviderId

